2015-03-03 - 17596 - Spec - Create crystal report master data for SNC #CrystalReportDevelopment
SPECIFICATIONS
17596 - Create crystal report master data for SNC
Requirement Summary
Need to create reports with vendor, material, plant and info-record master data for SNC.
Admin Info
Purpose
|
Need to create reports with vendor, material, plant and info-record master data for SNC.
|
Requested By
|
Kevin Boleware
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
03/03/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Master data for SNC Reports
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
14
|
4
|
Unit test in DEV
|
02
|
5
|
Unit test in QUA
|
02
|
6
|
NEC Crystal Checklist
|
02
|
|
TOTAL
|
24
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1.
|
SNC Report 1 changes:
- Remove the header and footer.
- Remove the leading zeros for the vendor and material.
- Please put plant in 2nd column & material in 3rd column.
- Plant shall be 4 characters.
- Remove the gap between each rows.
- Name the file starting with “SIM_” date and timestamp
|
Babu Vanamali
|
03/05/2015
|
|
2.
|
SNC Report 1 changes:
- Remove the header and footer. (Keep Header Vendor, Vendor Location , Plant Material)
- Add another column vendor in starting just given vendor number without leading zeros.
- Move material to last column and replace it with plants column.
|
Babu Vanamali
|
03/05/2015
|
|
3.
|
Change the output format of the reports as .CSV.
|
Babu Vanamali
|
03/10/2015
|
|
4.
|
SNC Report 2Name the file starting with “PHASE_” date and timestamp.
|
Babu Vanamali
|
03/11/2015
|
|
5.
|
And also requested to save the .CSV formats for the both reports in below location:
\\neccgwebapp2\sites\SNCREPORT\IN".
|
Babu Vanamali
|
03/11/2015
|
|
Functional Requirement
Purpose/WHY:
Need to create reports with vendor, material, plant and info-record master data for SNC. These reports shows master data for SNC.
In Scope:
SNC Master data reports.
Out of Scope:
None
Solution Summary
1. Need to add the fields like vendor, material, plant and info-record master data for SNC in the SNC Report 1.
2. Need to add the fields with headers like Vendor, Vendor Location , Plant, Material master data for SNC in the SNC Report 2.
3. Need to use the tables NAST, EKKO and EKPO.
4. Need to create 'create on date' & 'create at time' parameters to show the values with corresponding date in the reports.
5. Need to filter the data using following conditions from NAST table: Message type - ZSNC,,Application - EF and Process Status - 0.
6. Table Linking: NAST-OBJKY <--> EKKO-EBELN <--> EKPO-EBELN.
7. The output format of the reports is .CSV.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
4
|
Check the report output format i.s CSV.
|
Output format should be .CSV.
|
Solution Details
1. Need to add the fields like vendor, material, plant and info-record master data for SNC in the SNC Report 1.
2. Need to add the fields with headers like Vendor, Vendor Location , Plant, Material master data for SNC in the SNC Report 2.
3. Need to use the tables NAST, EKKO and EKPO.
4. Need to create 'create on date' & 'create at time' parameters to show the values with corresponding date in the reports.
5. Need to filter the data using following conditions from NAST table:
Message type - ZSNC
Application - EF
Process Status - 0
6. Table Linking: NAST-OBJKY <--> EKKO-EBELN <--> EKPO-EBELN
7. The output format of the reports is .CSV.
8. Testing and QA performed by NEC.
Issues
None